class CreateParamNorms < ActiveRecord::Migration
  def self.up
    create_table :param_norms do |t|
      t.string :name
      t.float :max_norm
      t.float :min_norm
      t.string :unit, :default => ""
      t.integer :examination_type_id
      t.timestamps
    end

        #------------Badania og�lne moczu
    ParamNorm.create :name => "Barwa",
                     :unit => "jednostka",
                     :max_norm => 3,
                     :min_norm => 2

    ParamNorm.create :name => "Przejrzystosc",
                     :unit => "jednostka",
                     :max_norm => 3,
                     :min_norm => 2

    ParamNorm.create :name => "Odczyn_pH",
                     :unit => "jednostka",
                     :max_norm => 7,
                     :min_norm => 4

    ParamNorm.create :name => "Ciezar_wlasciwy",
                     :unit => "mg",
                     :max_norm => 1,
                     :min_norm => 1
    #------------Badania og�lne moczu


    ParamNorm.create :name => "cukier",
                     :unit => "mg",
                     :max_norm => 14,
                     :min_norm => 12

    ParamNorm.create :name => "bialko",
                     :unit => "mg",
                     :max_norm => 3,
                     :min_norm => 2

  end

  def self.down
    drop_table :param_norms
  end
end
